DROP TABLE dbo.ProductType_Producer
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE ID = OBJECT_ID(N'ProductType_Producer') and OBJECTPROPERTY(ID, N'IsUserTable') = 1) BEGIN

   -- Create Employee 1:N table
   CREATE TABLE ProductType_Producer (
	[Id] INT  PRIMARY KEY IDENTITY,
   	[ProductTypeId] INT NOT NULL ,
   	[ProducerId] INT NOT NULL,
   	[IsDeleted] BIT NOT NULL
      -- Create non-clustered primary key
   
	FOREIGN KEY (ProductTypeId)	REFERENCES ProductType(Id),
	FOREIGN KEY (ProducerId)	REFERENCES Producer(Id)
	)
END








